package com.example.nonacademic_education.data.response;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.util.Date;
@Data
@ContentRowHeight(15)
public class StudentExcelDto {
    @ExcelProperty("序号")
    private Integer seq;
    @ExcelProperty("班级")
    @ColumnWidth(20)
    private String className;
    @ExcelProperty("学员姓名")
    @ColumnWidth(15)
    private String name;
    @ExcelProperty("性别")
    private String sex;
    @ExcelProperty("入学时间")
    @ColumnWidth(15)
    //@JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
    @DateTimeFormat("yyyy年MM月dd日")
    private Date enrollmentTime; // 入学时间
    @ExcelProperty("毕业时间")
    @ColumnWidth(15)
    //@JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
    @DateTimeFormat("yyyy年MM月dd日")
    private Date graduateTime; // 毕业时间
    @ExcelProperty("发放证书日期")
    @ColumnWidth(15)
    //@JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
    @DateTimeFormat("yyyy年MM月dd日")
    private Date creationTime; // 发放证书日期
    @ExcelProperty("证书编号")
    @ColumnWidth(30)
    private String certificateNo;   //证书编号
}
